<?
include("../../includes/global_files/tables.inc");
include(DOCINCLUDES."global_files/global_html.inc");
include(DOCINCLUDES."global_files/global_form.inc");//
include(DOCINCLUDES."global_files/global_report.inc");
include(DOCINCLUDES."global_files/tables.inc");
include(DOCINCLUDES."global_files/global_pgsql.inc");
include(DOCINCLUDES."global_files/global_functions.inc");

$page=new cPage;
$page->header_path="../../";

$form=new cForm();
$db=new cDatabase($company_id);
$report=new cReport();
$sql=new pgSql();//

$db->query="Select shipment_mode_id,shipment_mode_name from _mship_mode";	
$db->runQuery();
$city_array=$db->returnArrays();
// $gsp_no_val=$gsp_array[0]['gsp_id'];
foreach($city_array as $key=>$value)
{

echo $db->query="UPDATE _mship_mode SET shipment_mode_name='".strtoupper($value['shipment_mode_name'])."' where shipment_mode_id='". $value['shipment_mode_id']."'" ;	
$db->runQuery();

}
?>